﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_BBS_SetupBoardMember]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_BBS_SetupBoardMember];
GO
CREATE PROCEDURE [dbo].[sproc_BBS_SetupBoardMember]
@staffid int,
@boardid int

AS

    INSERT INTO uds_bbs_boardmember(board_id,staff_id)
    VALUES(@boardid,@staffid)